﻿<!DOCTYPE html>
<html>
	<head>
		<title>Data tab</title>
		<meta charset="utf-8" />
        <meta name="description" content="Introducing the Spreadsheet Editor user interface - Data tab" />
		<link type="text/css" rel="stylesheet" href="../../../../../../common/main/resources/help/editor.css" />
		<link type = "text/css" rel = "stylesheet" href = "../../images/sprite.css" />
        <script type="text/javascript" src="../callback.js"></script>
        <script type="text/javascript" src="../search/js/page-search.js"></script>
	</head>
	<body>
		<div class="mainpart">
            <div class="search-field">
                <input id="search" class="searchBar" placeholder="Search" type="text" onkeypress="doSearch(event)">
            </div>
			<h1>Data tab</h1>
            <p>The <b>Data</b> tab allows managing data in the <a href="https://www.onlyoffice.com/spreadsheet-editor.aspx" target="_blank" onclick="onhyperlinkclick(this)"><b>Spreadsheet Editor</b></a>.</p>
            <div class="onlineDocumentFeatures">
                <p>The corresponding window of the Online Spreadsheet Editor:</p>
                <p><img alt="Data tab" src="../images/interface/datatab.png" /></p>
            </div>
            <div class="desktopDocumentFeatures">
                <p>The corresponding window of the Desktop Spreadsheet Editor:</p>
                <p><img alt="Data tab" src="../images/interface/desktop_datatab.png" /></p>
            </div>
            <p>Using this tab, you can:</p>
            <ul>
                <li><a href="../UsageInstructions/SortData.htm" onclick="onhyperlinkclick(this)">sort and filter</a> data,</li>
                <li>convert <a href="../UsageInstructions/CopyPasteData.htm#delimiteddata" onclick="onhyperlinkclick(this)">text to columns</a>,</li>
                <li><a href="../UsageInstructions/RemoveDuplicates.htm" onclick="onhyperlinkclick(this)">remove duplicates</a> from a data range,</li>
                <li><a href="../UsageInstructions/GroupData.htm" onclick="onhyperlinkclick(this)">group and ungroup</a> data,</li>
                <li>set <a href="../UsageInstructions/DataValidation.htm" onclick="onhyperlinkclick(this)">data validation</a> parameters,</li>
                <li>find the <a href="../UsageInstructions/GoalSeek.htm" onclick="onhyperlinkclick(this)">right input</a> for the value that you want,</li>
                <li>get data <a href="../HelpfulHints/ImportData.htm" onclick="onhyperlinkclick(this)">from TXT/CSV file</a>,</li>
                <li>view other files the spreadsheet is <a href="../UsageInstructions/AddExternalLinks.htm" onclick="onhyperlinkclick(this)">linked to</a> via the <b>External Links</b> button.</li>
            </ul>
		</div>
	</body>
</html>
